Error Occurred While Processing Request

Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'ORDER'. SQL = "SELECT * FROM property WHERE propertyid = ORDER by name asc" Data Source = "RALOGDATA" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (13:2) to (13:64) in the template file F:\INETSRV\WWWROOT\WEBHOSTS\CHAMBER-OF-COMMERCE\WEBFILES\HOTEL2.HTML. Date/Time: 01/09/09 16:51:32 Browser: CCBot/1.0 (+http://www.commoncrawl.org/bot.html) Remote Address: 38.103.63.62

Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator).